/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 100137
 Source Host           : localhost:3306
 Source Schema         : test

 Target Server Type    : MySQL
 Target Server Version : 100137
 File Encoding         : 65001

 Date: 18/01/2019 16:09:11
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(30) NOT NULL,
  `age` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `gender` enum('0','1','2') NOT NULL DEFAULT '0',
  `birthday` int(13) unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES (14, 'lzhagnsan', 30, '1', 4294967295);
INSERT INTO `users` VALUES (20, 'lisi', 30, '1', 0);
INSERT INTO `users` VALUES (21, 'lwanger', 30, '1', 0);
INSERT INTO `users` VALUES (22, 'lmazi', 30, '1', 0);
INSERT INTO `users` VALUES (23, 'lniuniu', 108, '1', 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
